Release 10.1A: OpenEdge Development:
Progress 4GL Reference

Temp-table object handle

A handle to a temp-table object. A temp-table object handle corresponds to an underlying Progress temp-table, which can be static or dynamic. A static temp-table is one you define at compile time with the DEFINE TEMP-TABLE statement. A dynamic temp-table is one you create at run time with the CREATE TEMP-TABLE statement.

Syntax

temp-table-handle [ :attribute | :method ]

temp-table-handle

An item of type WIDGET-HANDLE representing a handle to a temp-table object.

attribute

An attribute of the temp-table object.

method

A method of the temp-table object.

Attributes

AFTER-TABLE attribute	BATCH-SIZE attribute	BEFORE-TABLE attribute
DATA-SOURCE-MODIFIED attribute	DEFAULT-BUFFER-HANDLE attribute	DYNAMIC attribute
ERROR attribute	ERROR-STRING attribute	HANDLE attribute
HAS-RECORDS attribute	LAST-BATCH attribute	MIN-SCHEMA-MARSHAL attribute
NAME attribute	NAMESPACE-PREFIX attribute	NAMESPACE-URI attribute
NO-SCHEMA-MARSHAL attribute	NUM-REFERENCES attribute	ORIGIN-HANDLE attribute
PREPARED attribute	PRIMARY attribute	REJECTED attribute
SCHEMA-MARSHAL attribute	TRACKING-CHANGES attribute	UNDO attribute

Methods

ADD-FIELDS-FROM( ) method	ADD-INDEX-FIELD( ) method
ADD-LIKE-FIELD( ) method	ADD-LIKE-INDEX( ) method
ADD-NEW-FIELD( ) method	ADD-NEW-INDEX( ) method
CLEAR( ) method	COPY-TEMP-TABLE( ) method
CREATE-LIKE( ) method	READ-XML( ) method
READ-XMLSCHEMA( ) method	TEMP-TABLE-PREPARE( ) method
WRITE-XML( ) method	WRITE-XMLSCHEMA( ) method

Example

The following code fragment demonstrates the creation, definition and use of a temp-table object:

DEFINE VARIABLE tth AS HANDLE. DEFINE VARIABLE bh AS HANDLE. DEFINE VARIABLE qh AS HANDLE. DEFINE VARIABLE buf-cust-handle AS HANDLE. /* get db table handle as usual */ buf-cust-handle = BUFFER customer:HANDLE. /* create an "empty" undefined temp-table */ CREATE TEMP-TABLE tth. /* give it customer’s fields and indexes */ tth:CREATE-LIKE(buf-cust-handle). /* give it a single extra field */ tth:ADD-NEW-FIELD("f1","integer"). /* no more fields or indexes will be added to custx */ tth:TEMP-TABLE-PREPARE("custx"). /* get the buffer handle for the temp-table */ bh = tth:DEFAULT-BUFFER-HANDLE. /*populate the table from customer table */ FOR EACH customer: bh:BUFFER-CREATE. bh:BUFFER-COPY(buf-cust-handle). END. /*run a query to access it*/ CREATE QUERY qh. qh:SET-BUFFERS(bh). qh:QUERY-PREPARE("for each custx where . . ."). . . .

Notes

The temp-table object has three states, CLEAR, UNPREPARED and PREPARED. The temp-table is in a CLEAR state either when the temp-table is first created or immediately after the CLEAR( ) method is applied. The temp-table is in an UNPREPARED state during the period after the first definitional method has been applied and before the TEMP-TABLE-PREPARE( ) method is applied. The temp-table is in a PREPARED state after the TEMP-TABLE-PREPARE( ) method has been applied.
The user can discern whether the temp-table is in an UNPREPARED or PREPARED state by using the PREPARED attribute.

See also

Buffer object handle, CREATE TEMP-TABLE statement, DEFINE TEMP-TABLE statement, ProDataSet object handle